Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
RetailTransactionLineItemSequenceNumber (FK)(PK) | The sequence number of line item within the context of this RetailTransaction. | IC_LN_ITM | LineNumber | smallint | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
SalesTaxSequenceNumber (FK)(PK) | A sequentially assigned number used to ensure a unique identity for SaleReturnTaxLineItem instances. | IC_SLS_TX_SQN_NMB | LineNumber | smallint | SaleReturnTaxLineItem(TR_LTM_SLS_RTN_TX) |
TaxGroupRuleID (FK) | System assigned unique identifier for the TaxGroupRule. | ID_RU_TX_GRP | Identity | integer | TaxGroupRule(RU_TX_GP) |
TaxableAmount | The monetary amount for which tax is applicable at the new rate. | MO_TXBL | MoneyShortRetail | decimal(7,2) | |
OriginalTaxAmount | The original amount of Tax that should've been collected but wasn't because of this TaxOverrideModifier. | MO_TX_ORGL | MoneyShortRetail | decimal(7,2) | |
NewTaxAmount | The new amount of Tax that is being collected because of this TaxOverrideModifier. | MO_TX_NEW | MoneyShortRetail | decimal(7,2) | |
OriginalTaxPercent | The original tax rate that should've been collected but wasn't because of this TaxOverrideModifier. | PE_TX_ORG | Percent | decimal(7,4) | |
NewTaxPercent | The new tax rate that is being collected because of this TaxOverrideModifier. | PE_TX_NEW | Percent | decimal(7,4) | |
ReasonCode (FK) | A retailer assigned reason code denoting why this TaxOverride is being granted. | CD_RSN | Code | varchar(20) | Reason(CO_CD_RSN) |
CustomerOverrideID | Identifier presented by Customer to get this tax override. Not used if Customer presents an individualised tax override certificate. | ID_OVRD_CT | IdentityAlphaNumeric | varchar(20) | |
CertificateNumber | A unique identifier taken from a TaxOverride certificate that was presented by the Customer in order to claim the TaxOverride. | ID_CF_TX_OVRD | IdentityAlphaNumeric | varchar(20) | |
CertificateHolderName | The name of the Customer taken from a TaxOverride certificate that was presented by the Customer in order to claim the TaxOverride. | NM_CF_HLDR | Name | varchar(40) | |